{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"merged":[[1,0,1,9],[23,3,23,9],[24,3,24,9],[25,3,25,9],[27,3,27,9],[28,3,28,9],[29,3,29,9],[30,3,30,9],[31,3,31,9],[35,3,35,4]],"flags":["formulas_cached_only"]}
[]
["Diminished Value Worksheet"]
[]
["DIV Number","00/00/00"]
[{"$nulls":9},"Vehicle Type "]
["Claim Number","0000000000000",{"$nulls":7},"US/Foreign Full size van",{"v":0.14,"d":"14%"}]
["State",{"$nulls":8},"High Performance Coupe ",{"v":0.25,"d":"25%"}]
["Owner",{"$nulls":8},"High Performance Sedan",{"v":0.25,"d":"25%"}]
[{"$nulls":9},"Hybrid",{"v":0.22,"d":"22%"}]
["Vehicle Year",{"$nulls":8},"Hybrid SUV",{"v":0.22,"d":"22%"}]
[{"$nulls":9},"European Luxury Sedan",{"v":0.22,"d":"22%"}]
["Vehicle make ",{"$nulls":8},"European Mid size",{"v":0.2,"d":"20%"}]
[{"$nulls":9},"Japanese Luxury Sedan ",{"v":0.22,"d":"22%"}]
["Vehicle Model",{"$nulls":8},"Japanese Mid size",{"v":0.1,"d":"10%"}]
[{"$nulls":9},"Japanese Compact",{"v":0.1,"d":"10%"}]
["ACV",0,{"$nulls":7},"US Luxury",{"v":0.22,"d":"22%"}]
[{"$nulls":9},"US Truck",{"v":0.18,"d":"18%"}]
["Base: LOV",0,null,{"v":0.1,"d":"0.10"},"% Based on type of vehicle",{"$nulls":4},"US Suv",{"v":0.16,"d":"16%"}]
[{"$nulls":9},"Mid Size",{"v":0.1,"d":"10%"}]
["Damage Severity:",{"v":0,"d":"0%"},null,"(see rating guide)",{"$nulls":5},"Compact ",{"v":0.1,"d":"10%"}]
[]
[null,"Guide"]
[]
[null,{"v":1,"d":"1.00"},null,"Severe Damage to structure, replaced mechanical parts , major panels replaced "]
[null,0.75,null,"Major Damage to structure and replaced Panels"]
[null,{"v":0.5,"d":"0.50"},null,"Moderate damage to structure, mechanical parts replaced and replaced panels"]
[null,{"v":0.4,"d":"0.40"},null,"Minor damage to structure, Mechanical parts replaced , Panels replaced"]
[null,{"v":0.3,"d":"0.30"},null,"Minor damage to structure of vehicle , refinish needed , panels replaced"]
[null,0.25,null,"Minor damage to structure of vehicle , refinish needed , panels damaged"]
[null,{"v":0.2,"d":"0.20"},null,"Minor Damage , refinish needed , minor parts replaced "]
[null,{"v":0.1,"d":"0.10"},null,"Minor repairs,  refinish needed "]
[null,{"v":0,"d":"0.00"},null,"Repairs only, no refinish work"]
[]
["Actual Mileage",0]
[]
["Mileage modifier",{"v":0,"d":"0.00"},null,"(based on 100,000 miles)"]
[{"$nulls":4},"Miles",null,"Modifier"]
[]
[{"$nulls":4},0,null,{"v":1,"d":"1.00"}]
[{"$nulls":4},{"v":10000,"d":"10,000"},null,{"v":0.9,"d":"0.90"}]
[{"$nulls":4},{"v":20000,"d":"20,000"},null,{"v":0.8,"d":"0.80"}]
[{"$nulls":4},{"v":30000,"d":"30,000"},null,{"v":0.7,"d":"0.70"}]
[{"$nulls":4},{"v":40000,"d":"40,000"},null,{"v":0.6,"d":"0.60"}]
[{"$nulls":4},{"v":50000,"d":"50,000"},null,{"v":0.5,"d":"0.50"}]
[{"$nulls":4},{"v":60000,"d":"60,000"},null,{"v":0.4,"d":"0.40"}]
[{"$nulls":4},{"v":70000,"d":"70,000"},null,{"v":0.3,"d":"0.30"}]
[{"$nulls":4},{"v":80000,"d":"80,000"},null,{"v":0.2,"d":"0.20"}]
[{"$nulls":4},{"v":90000,"d":"90,000"},null,{"v":0.1,"d":"0.10"}]
[{"$nulls":4},{"v":100000,"d":"100,000"},null,{"v":0,"d":"0.00"}]
[]
[]
["Base LOV:",0,"x","Damage severity",{"v":0,"d":"0.00"},"x","Mileage Modifier:",{"v":0,"d":"0.00"},"=","Diminished value",0]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}